

--回收站

CREATE TABLE Base_Recyclebin
(
	Recyclebin_ID VARCHAR2(50) NOT NULL PRIMARY KEY,
	Recyclebin_Name VARCHAR2(50),
	Recyclebin_Database VARCHAR2(50),
	Recyclebin_Table VARCHAR2(50),
	Recyclebin_FieldKey VARCHAR2(50),
	Recyclebin_EventField VARCHAR2(50),
	Recyclebin_Remark VARCHAR2(3500),
	CreateDate DATE DEFAULT(SYSDATE),
	CreateUserId VARCHAR2(50),
	CreateUserName VARCHAR2(50)
);

/*

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'回收站主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'Recyclebin_ID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'业务名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'Recyclebin_Name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应数据库' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'Recyclebin_Database'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应数据表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'Recyclebin_Table'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应字段主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'Recyclebin_FieldKey'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应字段值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'Recyclebin_EventField'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'Recyclebin_Remark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'CreateUserId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin', @level2type=N'COLUMN',@level2name=N'CreateUserName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'回收站' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_Recyclebin'
GO

ALTER TABLE [dbo].[Base_Recyclebin] ADD  CONSTRAINT [DF_Base_Recyclebin_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]
GO

*/